﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="UserStat.aspx.cs" Inherits="UserStat" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div style="font-size: 12px;">
    
        <br />
&nbsp;&nbsp; 年份：<asp:DropDownList ID="DropDownList1" runat="server">
            <asp:ListItem>2013</asp:ListItem>
            <asp:ListItem>2014</asp:ListItem>
            <asp:ListItem>2015</asp:ListItem>
            <asp:ListItem>2016</asp:ListItem>
        </asp:DropDownList>
        月：<asp:DropDownList ID="DropDownList2" runat="server">
            <asp:ListItem>1</asp:ListItem>
            <asp:ListItem>2</asp:ListItem>
            <asp:ListItem>3</asp:ListItem>
            <asp:ListItem>4</asp:ListItem>
            <asp:ListItem>5</asp:ListItem>
            <asp:ListItem>6</asp:ListItem>
            <asp:ListItem>7</asp:ListItem>
            <asp:ListItem>8</asp:ListItem>
            <asp:ListItem>9</asp:ListItem>
            <asp:ListItem>10</asp:ListItem>
            <asp:ListItem>11</asp:ListItem>
            <asp:ListItem>12</asp:ListItem>
        </asp:DropDownList>
        <asp:Button ID="Button1" runat="server" Text="查询" />
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:AirconConnectionString %>" 
            SelectCommand="StoredProcedure1" SelectCommandType="StoredProcedure">
            <SelectParameters>
                <asp:ControlParameter ControlID="DropDownList1" Name="y" 
                    PropertyName="SelectedValue" Type="Int32" />
                <asp:ControlParameter ControlID="DropDownList2" Name="m" 
                    PropertyName="SelectedValue" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
        <br />
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            BackColor="White" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" 
            CellPadding="4" DataSourceID="SqlDataSource1" Font-Size="12px" 
            HorizontalAlign="Center" Width="98%">
            <Columns>
                <asp:BoundField DataField="username" HeaderText="员工" 
                    SortExpression="username" />
                <asp:BoundField DataField="totals" HeaderText="总数" ReadOnly="True" 
                    SortExpression="totals" />
                <asp:BoundField DataField="WeiChuLi" HeaderText="未处理" ReadOnly="True" 
                    SortExpression="WeiChuLi" />
                <asp:BoundField DataField="MeiJie" HeaderText="未接" ReadOnly="True" 
                    SortExpression="MeiJie" />
                <asp:BoundField DataField="BuYao" HeaderText="不要" ReadOnly="True" 
                    SortExpression="BuYao" />
                <asp:BoundField DataField="GenJin" HeaderText="跟进" ReadOnly="True" 
                    SortExpression="GenJin" />
                <asp:BoundField DataField="QueShi" HeaderText="确实" ReadOnly="True" 
                    SortExpression="QueShi" />
            </Columns>
            <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
            <PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
            <RowStyle BackColor="White" ForeColor="#330099" />
            <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
            <SortedAscendingCellStyle BackColor="#FEFCEB" />
            <SortedAscendingHeaderStyle BackColor="#AF0101" />
            <SortedDescendingCellStyle BackColor="#F6F0C0" />
            <SortedDescendingHeaderStyle BackColor="#7E0000" />
        </asp:GridView>
    
    </div>
    </form>
</body>
</html>
